7c3677c8249e41b410cc2ab9d84287c46ba1f058,excel/src/test/java/com/bing/excel/Mytest.java,Mytest,testM,#,33
Before Change
File a = new File("d:/ad.s.xlsx");
System.out.println(a.getName());
boolean b = Pattern.matches(".*((\\.xls)|(\\.xlsx))$", null);
System.out.println(b);
}
@Test
After Change
*/
Workbook wb = WorkbookFactory.create(new File("F:/as.xlsx"));
Sheet sheet1 = wb.getSheetAt(0);
for (Row row : sheet1) {
for (Cell cell : row) {
CellReference cellRef = new CellReference(row.getRowNum(), cell.getColumnIndex());
System.out.print(cellRef.formatAsString());
System.out.print(" - ");
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING: